Executive Summary 23
********************************************************************

Executive Summary
********************************************************************


This Executive Summary section is a two part section.  


GIF - Your gif will take up the whole slide

Dashboard

ETL or Process

               1. Black Screen with Big White Font

               2. No more than 6 words per step

               3. Step will show up in the same place on every slide

               3. Colaberry Logo

               4. Each Slide will show for 2 seconds

               5. In between each step will be the screenshots of the work done in that step.  This includes screenshots from the Database, ETL package, code etc...

                              a. If you only have one slide for the step, you will show it for 2 seconds

                              b. If you have more than one slide for the step, you show each slide for one second each

                6. The end result is a 20-30 second (Under 5MB) fast pace moving GIF that summaries everything you've completed in the project.  This will represent the visual needed to showcase the great work you put in on the project.




Troubles that occurred on the Project


Dashboard Example:




Problems that occurred During Project  

1. Start working on this data set, the data was subset of the data, so the solutions was that the data set got fixed by the company. 
2.  having right company’s KPI by analyzing the data.  finally, one of the  company’s  KPI’s  was year over year, but in this data set there is only 20 months, so I cannot use year over. And then, instead of using the year over year calculation, changed to month over month. 






Troubles that occurred during the project
  1. The data coming from source had to be cleaned and remove special characters such as quotations, hyphens , dashes, etc.
  2. Finding the Calculation for Decade Over Decade. Researched different DAX formulas for the calculation. 





DW example:




ISSUES THAT OCCURRED DURING THE PROJECT

1. Unpivoting & Pivoting the Source Excel files 
 
 
 2. Converting the Quarter from 'NQYYYY' to Date format 'MM/DD/YYYY'
 




Instructions:

  1. Assign this task to yourself.
  2. Once you have read through this task and you fully understand it, write a small paragraph with screenshots and notes of what you learned.  Then add it as a comment on this task.
  3. Everyday you work on this task, you will add a minimal of a comment and a screenshot.  Gifs are good as well.
  4. Note: You as well as other people will be reading through your project notes.  Make sure you talk about your thoughts at the moment so you and others can relive the experience.
  5. Upon completion, close the task and navigate back to your Colaberry Project Dashboard.